<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80464406"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"MySQL连接日志 - jiuzhibuguniao的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>MySQL连接日志 - jiuzhibuguniao的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "jiuzhibuguniao";
        var blog_address = "https://blog.csdn.net/jiuzhibuguniao";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/jiuzhibuguniao/article/details/80464406"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "MySQL连接日志";
        var articleDesc = "1、pymysql.err.InternalError:(1130,u”Host‘218.20.44.100’isnotallowedtoconnecttothisMySqlserverMySQL拒绝远程访问usemysql;updateusersethost=%whereuser=root;flushprivileges;selecthost,u...";
        // 第四范式所需数据
        var articleTitles = "MySQL连接日志 - jiuzhibuguniao的博客";
        
        var nickName = "Rooobins";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/jiuzhibuguniao/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/jiuzhibuguniao/article/details/80464406";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">MySQL连接日志</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年05月26日 20:09:17</span>
                    <a class="follow-nickName" href="https://me.csdn.net/jiuzhibuguniao" target="_blank">Rooobins</a>
                    <span class="read-count">阅读数 2705</span>
                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            <p>1、<span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;background-color:rgb(255,255,255);">pymysql.err.InternalError: (1130, u”Host ‘218.20.44.100’ is not allowed to connect to this MySql server</span></p><p><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;"><span style="background-color:rgb(255,255,255);">MySQL拒绝远程访问</span></span></p><pre><code class="language-sql">use mysql;
update user set host='%' where user='root';</code></pre><pre><code class="language-sql">flush privileges;</code></pre><pre><code class="language-sql">select host,user from user;</code></pre><p>2、your password does not satisfy the current policy requirements</p><p></p><table summary="This table lists the password policies enforced                by the validate_password plugin and                describes the tests performed for each policy." border="1" style="border:1px solid #C0C0C0;color:rgb(85,85,85);font-family:'ms shell dlg';font-size:12px;background-color:rgb(255,255,255);"><thead><tr><th scope="col" style="border-color:#C0C0C0;border-collapse:collapse;padding:3px;">Policy</th><th scope="col" style="border-color:#C0C0C0;border-collapse:collapse;padding:3px;">Tests Performed</th></tr></thead><tbody><tr><td scope="row" style="font-size:12px;font-family:'HanHei SC', 'PingFang SC', 'Helvetica Neue', Helvetica, 'STHeitiSC-Light', Arial, sans-serif;margin:0px;line-height:1.5;border-color:#C0C0C0;border-collapse:collapse;padding:3px;"><code class="literal">0</code> or <code class="literal">LOW</code></td><td style="font-size:12px;font-family:'HanHei SC', 'PingFang SC', 'Helvetica Neue', Helvetica, 'STHeitiSC-Light', Arial, sans-serif;margin:0px;line-height:1.5;border-color:#C0C0C0;border-collapse:collapse;padding:3px;">Length</td></tr><tr><td scope="row" style="background-color:rgb(255,255,255);font-size:12px;font-family:'HanHei SC', 'PingFang SC', 'Helvetica Neue', Helvetica, 'STHeitiSC-Light', Arial, sans-serif;margin:0px;line-height:1.5;border-color:#C0C0C0;border-collapse:collapse;padding:3px;"><code class="literal">1</code> or <code class="literal">MEDIUM</code></td><td style="background-color:rgb(255,255,255);font-size:12px;font-family:'HanHei SC', 'PingFang SC', 'Helvetica Neue', Helvetica, 'STHeitiSC-Light', Arial, sans-serif;margin:0px;line-height:1.5;border-color:#C0C0C0;border-collapse:collapse;padding:3px;">Length; numeric, lowercase/uppercase, and special characters</td></tr><tr><td scope="row" style="font-size:12px;font-family:'HanHei SC', 'PingFang SC', 'Helvetica Neue', Helvetica, 'STHeitiSC-Light', Arial, sans-serif;margin:0px;line-height:1.5;border-color:#C0C0C0;border-collapse:collapse;padding:3px;"><code class="literal">2</code> or <code class="literal">STRONG</code></td><td style="font-size:12px;font-family:'HanHei SC', 'PingFang SC', 'Helvetica Neue', Helvetica, 'STHeitiSC-Light', Arial, sans-serif;margin:0px;line-height:1.5;border-color:#C0C0C0;border-collapse:collapse;padding:3px;">Length; numeric, lowercase/uppercase, and special characters; dictionary file</td></tr></tbody></table><pre><code class="language-sql">set global validate_password_policy=0;
set global validate_password_length=4;</code></pre><p>3、<span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">1045, "Access denied for user 'root'@'119.85.172.32' (using password: YES)"</span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">       关闭防火墙</span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">     <strong>此时登录不上去MySQL</strong></span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">     centos7下免密登录 </span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">     #vim /etc/my.cnf</span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">     在[mysqld]后面任意一行添加 skip-grant-tables 保存退出  用来跳过密码验证的过程</span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">     MySQL重启</span></span></p><pre><code class="language-sql">update mysql.user set authentication_string=password("password") where user="root"</code></pre><pre><code class="language-sql">flush privileges;</code></pre><p>      MySQL重启</p><p>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<br /></p><p>选择自己的登录用户名</p><pre><code class="language-sql">select user from mysql.user</code></pre>查看自己的所有用户，我把用户名root更改为Rooobins<br /><br /><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;background-color:rgb(255,255,255);"><span style="font-size:16px;">     </span></span></p><p><span style="color:rgb(51,51,51);font-family:'SF Pro Display', Roboto, Noto, Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', sans-serif;font-size:24px;font-weight:700;background-color:rgb(255,255,255);"><br /></span></p>                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/jiuzhibuguniao/article/details/80464406","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/jiuzhibuguniao/article/details/80464406","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="80464406">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/snowin1994/article/details/86615640","strategy":"BlogCommendFromAutoMl2","index":"0"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/snowin1994/article/details/86615640","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/snowin1994/article/details/86615640" target="_blank" title="mysql 连接失败的日志（或者输出）结果分析">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>连接</em>失败的<em>日志</em>（或者输出）结果分析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-23</span>
				<span class="read-num hover-hide">
					阅读数 
					243</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/snowin1994/article/details/86615640" target="_blank" title="mysql 连接失败的日志（或者输出）结果分析">
				<span class="desc oneline">情景复现小虎是一个后端开发。他使用客户端访问服务器A（IP：111.222.123.1）查询user表的数据，服务器A连接的数据库在服务器B（IP：111.222.123.2）上。访问后，在日志中获取...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/snowin1994">来自：	<span class="blog_title"> 孙雪峰</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u010316405/article/details/48137861","strategy":"BlogCommendFromAutoMl2","index":"1"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010316405/article/details/48137861","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010316405/article/details/48137861" target="_blank" title="mysql查看历史执行的sql">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看历史执行的sql		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-31</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010316405/article/details/48137861" target="_blank" title="mysql查看历史执行的sql">
				<span class="desc oneline">查看mysql的语句,比较常用的大概是showprocesslist命令了,但是这个对于查询时间比较长的语句比较有意义,对于一下子就能执行的语句真心拼不过手速啊.于是就只能从mysql的历史记录里面着...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010316405">来自：	<span class="blog_title"> u010316405的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lelemom/article/details/85935973","strategy":"BlogCommendFromAutoMl2","index":"2"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lelemom/article/details/85935973","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lelemom/article/details/85935973" target="_blank" title="mysql的六种日志  入门">
		<h4 class="text-truncate oneline">
				<em>mysql</em>的六种<em>日志</em>  入门		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-06</span>
				<span class="read-num hover-hide">
					阅读数 
					62</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lelemom/article/details/85935973" target="_blank" title="mysql的六种日志  入门">
				<span class="desc oneline">MySQL中有六种日志文件，分别是：重做日志（redolog）、回滚日志（undolog）、二进制日志（binlog）、错误日志（errorlog）、慢查询日志（slowquerylog）、一般查询日...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lelemom">来自：	<span class="blog_title"> lelemom的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Tink_bell/article/details/85938160","strategy":"BlogCommendFromAutoMl2","index":"3"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Tink_bell/article/details/85938160","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Tink_bell/article/details/85938160" target="_blank" title="查看mysql的日志">
		<h4 class="text-truncate oneline">
				查看<em>mysql</em>的<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-06</span>
				<span class="read-num hover-hide">
					阅读数 
					341</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Tink_bell/article/details/85938160" target="_blank" title="查看mysql的日志">
				<span class="desc oneline">有时候，我们通过EF或者其他的ORM和数据库进行数据交换，这样我们不方便看到执行的sql语句，我们可以借助一些工具代理来查看，像SQLServer安装的时候就自带Profiler，可以很方便的看到执行...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Tink_bell">来自：	<span class="blog_title"> 张连康 不懂人情世故的天才</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/index_ling/article/details/84062215","strategy":"BlogCommendFromAutoMl2","index":"4"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/index_ling/article/details/84062215","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/index_ling/article/details/84062215" target="_blank" title="Mysql访问日志记录">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>访问<em>日志</em>记录		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-14</span>
				<span class="read-num hover-hide">
					阅读数 
					101</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/index_ling/article/details/84062215" target="_blank" title="Mysql访问日志记录">
				<span class="desc oneline">Mysql访问日志记录假设这么一个情况，你是某公司mysql-DBA，某日突然公司数据库中的所有被人为删了。尽管有数据备份，但是因服务停止而造成的损失上千万，现在公司需要查出那个做删除操作的人。但是拥...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/index_ling">来自：	<span class="blog_title"> index_ling的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34354945/article/details/92476846","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34354945/article/details/92476846","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34354945/article/details/92476846" target="_blank" title="mysql开启用户(登录)审计功能">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启用户(登录)审计功能		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-09</span>
				<span class="read-num hover-hide">
					阅读数 
					5</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34354945/article/details/92476846" target="_blank" title="mysql开启用户(登录)审计功能">
				<span class="desc oneline">转自http://ourmysql.com/archives/788背景：假设这么一个情况，你是某公司mysql-DBA，某日突然公司数据库中的所有被人为删了。尽管有数据备份，但是因服务停止而造成的损...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34354945">来自：	<span class="blog_title"> weixin_34354945的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392558531","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392558531","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<a href="https://bbs.csdn.net/topics/392558531" target="_blank">
		<h4 class="text-truncate oneline">
				如何查看<em>mysql</em>数据库操作记录<em>日志</em>？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">03-25</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">1、首先确认你日志是否启用了mysql&gt;show variables like 'log_bin'。 2、如果启用了，即ON，那日志文件就在mysql的安装目录的data目录下。 3、怎样知道当前的日</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Alen_Liu_SZ/article/details/90116403","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Alen_Liu_SZ/article/details/90116403","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Alen_Liu_SZ/article/details/90116403" target="_blank" title="【MySQL】MySQL日志文件总结">
		<h4 class="text-truncate oneline">
				【<em>MySQL</em>】<em>MySQL</em><em>日志</em>文件总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-11</span>
				<span class="read-num hover-hide">
					阅读数 
					42</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Alen_Liu_SZ/article/details/90116403" target="_blank" title="【MySQL】MySQL日志文件总结">
				<span class="desc oneline">MySQL数据库中根据日志文件的不同，可分为以下几种，下面将分别介绍。一错误日志1描述记录MySQL的启动、停止信息以及在MySQL运行过程中的错误信息，类似于Oracle数据库的alertlog，默...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Alen_Liu_SZ">来自：	<span class="blog_title"> 温故而知新，可以为师矣</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34238633/article/details/85912139","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34238633/article/details/85912139","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34238633/article/details/85912139" target="_blank" title="MySQL查询日志总结">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>查询<em>日志</em>总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-07</span>
				<span class="read-num hover-hide">
					阅读数 
					26</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34238633/article/details/85912139" target="_blank" title="MySQL查询日志总结">
				<span class="desc oneline"> MySQL查询日志介绍  MySQL的查询日志记录了所有MySQL数据库请求的信息。无论这些请求是否得到了正确的执行。默认文件名为hostname.log。默认情况下MySQL查询日志是关闭的。生产...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34238633">来自：	<span class="blog_title"> weixin_34238633的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34081595/article/details/85987922","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34081595/article/details/85987922","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34081595/article/details/85987922" target="_blank" title="详细分析MySQL的日志(一)">
		<h4 class="text-truncate oneline">
				详细分析<em>MySQL</em>的<em>日志</em>(一)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-07</span>
				<span class="read-num hover-hide">
					阅读数 
					7</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34081595/article/details/85987922" target="_blank" title="详细分析MySQL的日志(一)">
				<span class="desc oneline">官方手册:https://dev.mysql.com/doc/refman/5.7/en/server-logs.html不管是哪个数据库产品，一定会有日志文件。在MariaDB/MySQL中，主要有...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34081595">来自：	<span class="blog_title"> weixin_34081595的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/360202787","strategy":"BlogCommendFromBaidu","index":"10"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/360202787","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<a href="https://bbs.csdn.net/topics/360202787" target="_blank">
		<h4 class="text-truncate oneline">
				怎样查询访问数据库的<em>日志</em>?		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">05-09</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我单位因业务原因在一机关单位创建了一个数据库A,数据库管理员创建一个数据库dbo角色的用户U给我单位访问这个数据库A,但是管理员同时提供这个用户U给另外一个单位C使用(因为该单位C要访问我们的数据库数</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zhou920786312/article/details/78009665","strategy":"BlogCommendFromBaidu","index":"11"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhou920786312/article/details/78009665","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhou920786312/article/details/78009665" target="_blank" title="mysql查看日志和启用日志">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看<em>日志</em>和启用<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-17</span>
				<span class="read-num hover-hide">
					阅读数 
					7457</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhou920786312/article/details/78009665" target="_blank" title="mysql查看日志和启用日志">
				<span class="desc oneline">查看日志SHOWVARIABLESLIKE&quot;general_log%&quot;;启用日志SETGLOBALgeneral_log='ON';</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhou920786312">来自：	<span class="blog_title"> zhou920786312的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/cd18333612683/article/details/69899077","strategy":"BlogCommendFromBaidu","index":"12"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cd18333612683/article/details/69899077","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cd18333612683/article/details/69899077" target="_blank" title="Mysql的几种日志">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>的几种<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-09</span>
				<span class="read-num hover-hide">
					阅读数 
					1727</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cd18333612683/article/details/69899077" target="_blank" title="Mysql的几种日志">
				<span class="desc oneline">错误日志错误日志记录着mysqld启动和停止,以及服务器在运行过程中发生的错误的相关信息。在默认情况下，系统记录错误日志的功能是关闭的，错误信息被输出到标准错误输出。指定日志路径两种方法编辑my.cn...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cd18333612683">来自：	<span class="blog_title"> 在努力~丹</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/hellorichen/article/details/80760178","strategy":"BlogCommendFromBaidu","index":"13"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hellorichen/article/details/80760178","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hellorichen/article/details/80760178" target="_blank" title="mysql 5.7日志查看">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 5.7<em>日志</em>查看		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					2563</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hellorichen/article/details/80760178" target="_blank" title="mysql 5.7日志查看">
				<span class="desc oneline">1.cmd连接mysql。2.showvariableslike'%log%';结果如图所示： 其中，general_log默认关闭。3.找到mysql的my.ini文件，目录为：C:\Program...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hellorichen">来自：	<span class="blog_title"> hellorichen的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_19704/article/details/82329878","strategy":"BlogCommendFromBaidu","index":"14"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_19704/article/details/82329878","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_19704/article/details/82329878" target="_blank" title="mysql 的日志的启动与查看 ">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 的<em>日志</em>的启动与查看 		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-11</span>
				<span class="read-num hover-hide">
					阅读数 
					31</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_19704/article/details/82329878" target="_blank" title="mysql 的日志的启动与查看 ">
				<span class="desc oneline">ysql有以下几种日志：错误日志：-log-err查询日志：-log慢查询日志:-log-slow-queries更新日志:-log-update二进制日志：-log-bin默认情况下，所有日志创建于...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_19704">来自：	<span class="blog_title"> zxlin25</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qiezikuaichuan/article/details/47445749","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qiezikuaichuan/article/details/47445749","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qiezikuaichuan/article/details/47445749" target="_blank" title="如何查看mysql运行、访问记录等日志">
		<h4 class="text-truncate oneline">
				如何查看<em>mysql</em>运行、访问记录等<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-12</span>
				<span class="read-num hover-hide">
					阅读数 
					5778</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qiezikuaichuan/article/details/47445749" target="_blank" title="如何查看mysql运行、访问记录等日志">
				<span class="desc oneline">分类： Mysql/postgreSQL1.首先确认你日志是否启用了mysql&gt;showvariableslike'log_bin';2.如果启用了，即ON那日志文件就在mysql的安装目录的data...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qiezikuaichuan">来自：	<span class="blog_title"> qiezikuaichuan的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/a351945755/article/details/28239819","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a351945755/article/details/28239819","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a351945755/article/details/28239819" target="_blank" title="MYSQL启用日志，和查看日志">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>启用<em>日志</em>，和查看<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-03</span>
				<span class="read-num hover-hide">
					阅读数 
					6万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a351945755/article/details/28239819" target="_blank" title="MYSQL启用日志，和查看日志">
				<span class="desc oneline">mysql有以下几种日志：    错误日志：    -log-err    查询日志：    -log    慢查询日志:  -log-slow-queries    更新日志:    -log-up...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a351945755">来自：	<span class="blog_title"> 明明</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/STFPHP/article/details/53572437","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/STFPHP/article/details/53572437","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/STFPHP/article/details/53572437" target="_blank" title="MySQL 基于日志点复制">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 基于<em>日志</em>点复制		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-11</span>
				<span class="read-num hover-hide">
					阅读数 
					1707</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/STFPHP/article/details/53572437" target="_blank" title="MySQL 基于日志点复制">
				<span class="desc oneline">MySQL的复制功能不仅可以构建高性能的应用，也是高可用性、可扩展性、灾难恢复等工作的基础。复制的主要功能1、数据分布。MySQL提供的复制功能并不需要很大的带宽的要求，因此可以在不同的物理位置来分布...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/STFPHP">来自：	<span class="blog_title"> yyyiue的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/robinson_0612/article/details/39779225","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/robinson_0612/article/details/39779225","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/robinson_0612/article/details/39779225" target="_blank" title="MySQL 通用查询日志(General Query Log)">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 通用查询<em>日志</em>(General Query Log)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-04</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/robinson_0612/article/details/39779225" target="_blank" title="MySQL 通用查询日志(General Query Log)">
				<span class="desc oneline">同大多数关系型数据库一样，日志文件是MySQL数据库的重要组成部分。MySQL有几种不同的日志文件，通常包括错误日志文件，二进制日志，通用日志，慢查询日志，等等。这些日志可以帮助我们定义mysqld内...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/robinson_0612">来自：	<span class="blog_title"> 乐沙弥的世界</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/SAN_YUN/article/details/84921773","strategy":"BlogCommendFromBaidu","index":"19"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/SAN_YUN/article/details/84921773","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/SAN_YUN/article/details/84921773" target="_blank" title="MySQL 中的重做日志，回滚日志 ，以及二进制日志的简单总结">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 中的重做<em>日志</em>，回滚<em>日志</em> ，以及二进制<em>日志</em>的简单总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-06</span>
				<span class="read-num hover-hide">
					阅读数 
					101</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/SAN_YUN/article/details/84921773" target="_blank" title="MySQL 中的重做日志，回滚日志 ，以及二进制日志的简单总结">
				<span class="desc oneline">ImportNew5天前（点击上方公众号，可快速关注）来源：MSSQL123，www.cnblogs.com/wy123/p/8365234.htmlMySQL中有六种日志文件，分别是：重做日志（re...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/SAN_YUN">来自：	<span class="blog_title"> SAN_YUN的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Dian1pei2xiao3/article/details/88948236","strategy":"BlogCommendFromBaidu","index":"20"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Dian1pei2xiao3/article/details/88948236","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Dian1pei2xiao3/article/details/88948236" target="_blank" title="Mysql:Mysql四种日志的设置、启动、查看和删除操作">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>:<em>Mysql</em>四种<em>日志</em>的设置、启动、查看和删除操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-01</span>
				<span class="read-num hover-hide">
					阅读数 
					438</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Dian1pei2xiao3/article/details/88948236" target="_blank" title="Mysql:Mysql四种日志的设置、启动、查看和删除操作">
				<span class="desc oneline">Mysql日志是记录Mysql数据库的日常操作和错误信息的文件。当数据库遭到意外的损害时，可以通过日志文件来查询出错原因，并且可以通过日志文件进行数据恢复。用来记录Mysql数据库的客户端连接情况、S...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Dian1pei2xiao3">来自：	<span class="blog_title"> 颠沛的小丸子</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u011982967/article/details/81189013","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u011982967/article/details/81189013","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011982967/article/details/81189013" target="_blank" title="mysql  打开日志，并输出为文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>  打开<em>日志</em>，并输出为文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1062</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011982967/article/details/81189013" target="_blank" title="mysql  打开日志，并输出为文件">
				<span class="desc oneline">mysql保存日志mysql有四种日志：所有日志：generallog慢查询日志：slowlog二进制日志：binarylog错误日志：errorlogwindows下在my.ini里配置，linux...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011982967">来自：	<span class="blog_title"> BrightSt的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/codechelle/article/details/79028285","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/codechelle/article/details/79028285","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/codechelle/article/details/79028285" target="_blank" title="mysql 的错误日志在哪里">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 的错误<em>日志</em>在哪里		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-10</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/codechelle/article/details/79028285" target="_blank" title="mysql 的错误日志在哪里">
				<span class="desc oneline">https://zhidao.baidu.com/question/623835136776873524.html如果你什么都没改过，如果是windows下，一般是安装目录下的data目录下扩展名是....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/codechelle">来自：	<span class="blog_title"> codechelle的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wll_1017/article/details/44979539","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wll_1017/article/details/44979539","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wll_1017/article/details/44979539" target="_blank" title="mysql 几种日志">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 几种<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-10</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wll_1017/article/details/44979539" target="_blank" title="mysql 几种日志">
				<span class="desc oneline">mysql5.5有以下几种日志： 错误日志(errorlog)：log-err查询日志(general querylog)：log慢查询日志:-log-slow-queries    二进制日志(bi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wll_1017">来自：	<span class="blog_title"> wll的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391991735","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391991735","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<a href="https://bbs.csdn.net/topics/391991735" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> root 用户的登录<em>日志</em>是在哪查看的？		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-28</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql root 用户的登录日志是在哪查看的？</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391970060","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391970060","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<a href="https://bbs.csdn.net/topics/391970060" target="_blank">
		<h4 class="text-truncate oneline">
				求大神 <em>Mysql</em> 怎么查看远程登陆<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-20</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我开了2个远程数据库用户 1 2 是给2个客户用的 我怎么才能查看 1 2的登陆情况呢 还是说Mysql没有这个功能 新手求带</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392437017","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392437017","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<a href="https://bbs.csdn.net/topics/392437017" target="_blank">
		<h4 class="text-truncate oneline">
				linux 系统<em>mysql</em> 登录<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">08-23</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">请问linux环境下mysql有没有记录非法登录的日志。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wangzhengwei2010/article/details/53447323","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wangzhengwei2010/article/details/53447323","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wangzhengwei2010/article/details/53447323" target="_blank" title="MySQL服务器日志（1）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>服务器<em>日志</em>（1）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1784</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wangzhengwei2010/article/details/53447323" target="_blank" title="MySQL服务器日志（1）">
				<span class="desc oneline">MySQL服务器有以下几种类型的日志，通过这些日志，可以知道服务器的活动；错误日志：记录了mysqld启动、运行、停止时，所遇到的问题；常规查询日志：日志记录了服务器建立的客户端连接，以及来自客户端的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wangzhengwei2010">来自：	<span class="blog_title"> 学无止境</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/340090963","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/340090963","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<a href="https://bbs.csdn.net/topics/340090963" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 查15分钟内登录的<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-02</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">登录日志表 中的字段： userLoginTime datetime 类型 要查15分钟 登录的日志如何查 select * from userlogtable where userLoginTime</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/catemo/article/details/53155447","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/catemo/article/details/53155447","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/catemo/article/details/53155447" target="_blank" title="mysql笔记(三)-- 用户登录(二):保存用户操作日志的方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>笔记(三)-- 用户登录(二):保存用户操作<em>日志</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-14</span>
				<span class="read-num hover-hide">
					阅读数 
					4068</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/catemo/article/details/53155447" target="_blank" title="mysql笔记(三)-- 用户登录(二):保存用户操作日志的方法">
				<span class="desc oneline">现在我们接着上节课，完成第二个功能，不管成功不成功都记录一个日志。　　一、回顾上节课内容，我们在user_log表中添加一个字段user_id.　　　　 在上一节课的存储过程新增一行代码，如下：BEG...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/catemo">来自：	<span class="blog_title"> catemo的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zhengwish/article/details/50732581","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhengwish/article/details/50732581","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhengwish/article/details/50732581" target="_blank" title="mysql开启错误日志！！！">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启错误<em>日志</em>！！！		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-24</span>
				<span class="read-num hover-hide">
					阅读数 
					9811</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhengwish/article/details/50732581" target="_blank" title="mysql开启错误日志！！！">
				<span class="desc oneline">环境：本地环境wamp[win10;mysql5.6;php5.5.12;apache2.4]需求:开启mysql错误日志需求引子：因为要开启缓存。加入配置信息到my.ini，重启后，console打...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhengwish">来自：	<span class="blog_title"> zhengwish的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/nightelve/article/details/17241659","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/nightelve/article/details/17241659","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nightelve/article/details/17241659" target="_blank" title="开启mysql操作日志">
		<h4 class="text-truncate oneline">
				开启<em>mysql</em>操作<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-10</span>
				<span class="read-num hover-hide">
					阅读数 
					4566</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nightelve/article/details/17241659" target="_blank" title="开启mysql操作日志">
				<span class="desc oneline">今天开发问我,mysql有无操作日志可查,查了下手册,还真有,不过默认情况下是没有开启的,开启步骤如下:1,在/etc/my.cnfmysqld后面添加log=/var/lib/mysql/mysql...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/nightelve">来自：	<span class="blog_title"> 0li's Blog</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/molaifeng/article/details/17395023","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/molaifeng/article/details/17395023","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/molaifeng/article/details/17395023" target="_blank" title="mysql开启日志功能">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启<em>日志</em>功能		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-18</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/molaifeng/article/details/17395023" target="_blank" title="mysql开启日志功能">
				<span class="desc oneline">今天中午，经理过来说把项目的日志功能给开开，方便以后查看性能，一开始是他弄，嘿，转项目经理久了，技术就难免生疏了，就说了下怎么怎么弄。他走后，我便集中精力搞这个了，以前没弄过，于是乎，出现了一堆问题，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/molaifeng">来自：	<span class="blog_title"> molaifeng的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/mliu222/article/details/6436640","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/mliu222/article/details/6436640","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mliu222/article/details/6436640" target="_blank" title="MySql 的操作日志">
		<h4 class="text-truncate oneline">
				<em>MySql</em> 的操作<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-21</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mliu222/article/details/6436640" target="_blank" title="MySql 的操作日志">
				<span class="desc oneline">任何一种数据库中，都有各种各样的日志。Mysql也不例外，在Mysql中有4种不同的日志、分别错误日志、二进制日志、查询日志和慢查询日志。这些日志记录着Mysql数据库不同方面的踪迹。下文将介绍这4种...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/mliu222">来自：	<span class="blog_title"> mliu222的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/win_turn/article/details/56488571","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/win_turn/article/details/56488571","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/win_turn/article/details/56488571" target="_blank" title="设置和查询mysql错误日志、访问日志">
		<h4 class="text-truncate oneline">
				设置和查询<em>mysql</em>错误<em>日志</em>、访问<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-22</span>
				<span class="read-num hover-hide">
					阅读数 
					4700</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/win_turn/article/details/56488571" target="_blank" title="设置和查询mysql错误日志、访问日志">
				<span class="desc oneline">日志类型mysql有以下几种日志：错误日志：log-err查询日志：log慢查询日志:log-slow-queries更新日志:log-update二进制日志：log-bin命令查看是否启用了日志my...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/win_turn">来自：	<span class="blog_title"> win_turn的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/nuli888/article/details/52106910","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/nuli888/article/details/52106910","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nuli888/article/details/52106910" target="_blank" title="mysql查看binlog日志内容">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看binlog<em>日志</em>内容		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-03</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nuli888/article/details/52106910" target="_blank" title="mysql查看binlog日志内容">
				<span class="desc oneline">mysql的binlog日志位置可通过showvariableslike'%datadir%';查看，直接打开是乱码，要看其内容2个办法：1、登录到mysql查看binlog只查看第一个binlog文...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/nuli888">来自：	<span class="blog_title"> 爱代码也爱生活</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/yzhbyssgdbd123/article/details/89374094","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yzhbyssgdbd123/article/details/89374094","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yzhbyssgdbd123/article/details/89374094" target="_blank" title="mysql登录异常记录">
		<h4 class="text-truncate oneline">
				<em>mysql</em>登录异常记录		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-18</span>
				<span class="read-num hover-hide">
					阅读数 
					98</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yzhbyssgdbd123/article/details/89374094" target="_blank" title="mysql登录异常记录">
				<span class="desc oneline">root用户登录报错：Accessdeniedforuser'root'@'localhost'(usingpassword:YES)；root用户拒绝访问。解决一：cd/etc/vimmy.cnf加...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yzhbyssgdbd123">来自：	<span class="blog_title"> yzhbyssgdbd123的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34457768/article/details/79423569","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34457768/article/details/79423569","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34457768/article/details/79423569" target="_blank" title="mysql开启通用日志">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启通用<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-02</span>
				<span class="read-num hover-hide">
					阅读数 
					1186</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34457768/article/details/79423569" target="_blank" title="mysql开启通用日志">
				<span class="desc oneline">mysql开启通用日志（即所有的操作包括select语句都会产生记录并保存在日志里）1、mysql默认是关闭通用日志的，可以用show variables like '%general%';查看当前状...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34457768">来自：	<span class="blog_title"> qq_34457768的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zhushiq1234/article/details/86358902","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhushiq1234/article/details/86358902","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhushiq1234/article/details/86358902" target="_blank" title="Mysql数据库日志文件">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>数据库<em>日志</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-12</span>
				<span class="read-num hover-hide">
					阅读数 
					379</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhushiq1234/article/details/86358902" target="_blank" title="Mysql数据库日志文件">
				<span class="desc oneline">    日志文件记录了影响Mysql数据库的各种类型活动，Mysql数据库中常见的日志文件有： 错误日志	 二进制日志	 慢查询日志	 查询日志    这些日志文件可以帮助DBA对数据库的运行状态进行...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhushiq1234">来自：	<span class="blog_title"> 1234的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_16885135/article/details/52524552","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_16885135/article/details/52524552","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_16885135/article/details/52524552" target="_blank" title="关于远程访问ubuntu服务器中mysql和memcache的一些总结">
		<h4 class="text-truncate oneline">
				关于远程访问ubuntu服务器中<em>mysql</em>和memcache的一些总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-13</span>
				<span class="read-num hover-hide">
					阅读数 
					253</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_16885135/article/details/52524552" target="_blank" title="关于远程访问ubuntu服务器中mysql和memcache的一些总结">
				<span class="desc oneline">领导分配一个任务，需要远程访问一台ubuntu服务器上的mysql和memcache。首先需要配置mysql，使其允许远程访问：登录ubuntu服务器，我发现mysql的user是这样配置的selec...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_16885135">来自：	<span class="blog_title"> qq_763034592的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390159781","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390159781","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<a href="https://bbs.csdn.net/topics/390159781" target="_blank">
		<h4 class="text-truncate oneline">
				如何查询远程<em>mysql</em>的<em>日志</em>。		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">08-02</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">现在只能以mysql -h10.10.10.10 -uroot -p 访问远程mysql。 遇到的问题是，我是不能登录，远程mysql服务器机器，导致我不能查看 msyql的日志。 不知到有其他什么方</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wunianjiumeng/article/details/80091484","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wunianjiumeng/article/details/80091484","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wunianjiumeng/article/details/80091484" target="_blank" title="mysql查看日志文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看<em>日志</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wunianjiumeng/article/details/80091484" target="_blank" title="mysql查看日志文件">
				<span class="desc oneline">查看日志文件MySQL维护管理员依赖的一系列日志文件。主要文件有以下几种1错误日志。它包含启动和关闭问题以及任意根据错误的细节。此日志通常名为hostname.err.2查询日志。它记录所有MySQL...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wunianjiumeng">来自：	<span class="blog_title"> 勿念旧梦</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392276144","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392276144","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<a href="https://bbs.csdn.net/topics/392276144" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 错误<em>日志</em>没有生成 log_error		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">10-19</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">在mysql配置文件my.cnf中已经指定log_error路径 在启动的时候报错 现在想看错误信息。对应的路径里面没有错误日志 请问这个是什么原因？</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_38092942/article/details/80647407","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/m0_38092942/article/details/80647407","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/m0_38092942/article/details/80647407" target="_blank" title="mysql开启日志，用于记录所有对数据库的操作，分析原因">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启<em>日志</em>，用于记录所有对数据库的操作，分析原因		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-13</span>
				<span class="read-num hover-hide">
					阅读数 
					1190</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/m0_38092942/article/details/80647407" target="_blank" title="mysql开启日志，用于记录所有对数据库的操作，分析原因">
				<span class="desc oneline">开启日志操作1.ps-ef|grepmysqld2./usr/local/mysql/bin/mysql-uroot-p--socket=/tmp/mysql.sock3.showvariablesl...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/m0_38092942">来自：	<span class="blog_title"> OHHINK博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/kajweb/article/details/78820047","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/kajweb/article/details/78820047","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kajweb/article/details/78820047" target="_blank" title="记录mysql操作日志">
		<h4 class="text-truncate oneline">
				记录<em>mysql</em>操作<em>日志</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-16</span>
				<span class="read-num hover-hide">
					阅读数 
					2666</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kajweb/article/details/78820047" target="_blank" title="记录mysql操作日志">
				<span class="desc oneline">现在想比对php网页执行前后的差异，但是一直找不到比较好的软件增删查改都记录的那种。。。然后通过浏览官方文档发现MySQL5。1有一个通用查询日志。于是尝试：#cd/Applications/XAMP...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kajweb">来自：	<span class="blog_title"> 林毅洋</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u014796999/article/details/53251816","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u014796999/article/details/53251816","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u014796999/article/details/53251816" target="_blank" title="mysql开启日志方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启<em>日志</em>方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-21</span>
				<span class="read-num hover-hide">
					阅读数 
					5305</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u014796999/article/details/53251816" target="_blank" title="mysql开启日志方法">
				<span class="desc oneline">mysql配置文件加如下代码：log-error=&quot;D:/phpStudy/MySQL/logs/error.log&quot;log=&quot;D:/phpStudy/MySQL/logs/mysql.log&quot;lon...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u014796999">来自：	<span class="blog_title"> u014796999的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zyb378747350/article/details/78728886","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zyb378747350/article/details/78728886","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zyb378747350/article/details/78728886" target="_blank" title="查看MySQL4种日志参数及配置">
		<h4 class="text-truncate oneline">
				查看<em>MySQL</em>4种<em>日志</em>参数及配置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-06</span>
				<span class="read-num hover-hide">
					阅读数 
					4516</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zyb378747350/article/details/78728886" target="_blank" title="查看MySQL4种日志参数及配置">
				<span class="desc oneline">1查看版本mysql&gt;showvariableslike'%version';+------------------+---------------+|Variable_name  |Value   ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zyb378747350">来自：	<span class="blog_title"> zyb378747350的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33414506/article/details/80580751","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33414506/article/details/80580751","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_33414506/article/details/80580751" target="_blank" title="如何通过命令行连接mysql">
		<h4 class="text-truncate oneline">
				如何通过命令行<em>连接</em><em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-05</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_33414506/article/details/80580751" target="_blank" title="如何通过命令行连接mysql">
				<span class="desc oneline">1.如何通过命令行连接mysql数据库windows端：需要在命令行中进入mysql所在的目录下，进入bin目录下：比如我的路径是在：e:\tmallStudy\mysql\MySQLServer5....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_33414506">来自：	<span class="blog_title"> qq_33414506的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/DOUBLEchen151/article/details/81409166","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/DOUBLEchen151/article/details/81409166","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/DOUBLEchen151/article/details/81409166" target="_blank" title="重新安装后mysql的启动与登陆（个人日志）">
		<h4 class="text-truncate oneline">
				重新安装后<em>mysql</em>的启动与登陆（个人<em>日志</em>）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-04</span>
				<span class="read-num hover-hide">
					阅读数 
					119</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/DOUBLEchen151/article/details/81409166" target="_blank" title="重新安装后mysql的启动与登陆（个人日志）">
				<span class="desc oneline">重新安装后mysql的启动与登陆</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/DOUBLEchen151">来自：	<span class="blog_title"> DOUBLEchen151的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_32566003/article/details/85609298","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_32566003/article/details/85609298","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_32566003/article/details/85609298" target="_blank" title="mysql 的日志路径">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 的<em>日志</em>路径		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-02</span>
				<span class="read-num hover-hide">
					阅读数 
					1467</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_32566003/article/details/85609298" target="_blank" title="mysql 的日志路径">
				<span class="desc oneline">首先找到mysql安装路径例如我的C:\ProgramFiles\MySQL\MySQLServer5.7\bin打开cmd命令行切换到安装路径下，登录mysqlmysql-uroot-pSHOWGL...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_32566003">来自：	<span class="blog_title"> 她如花似玉</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtTaYgxsODgtZWR1.html" target="_blank">
                        web连接mysql教程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtzaEg4sODctZWR1.html" target="_blank">
                        云计算课程日志</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/jiuzhibuguniao">
              <img src="https://avatar.csdn.net/B/F/9/3_jiuzhibuguniao.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/7.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/jiuzhibuguniao"  class="" id="uid">Rooobins</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="15">
                        <dt><a href="https://blog.csdn.net/jiuzhibuguniao?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/jiuzhibuguniao?t=1"><span class="count">15</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="1">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">1</span></dd>
        </dl>
        <dl class="text-center" title="0">
            <dt>喜欢</dt>
            <dd><span class="count">0</span></dd>
        </dl>
        <dl class="text-center" title="9">
            <dt>评论</dt>
            <dd><span class="count">9</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="11632">
                1万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="283">
                283            </dd>
        </dl>
        <dl title="348429">
            <dt>排名：</dt>
            <dd>34万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="GitHub">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/github.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/github.svg" alt="">
                                   <p>GitHub</p>
                               </div>
                               <div class="right-box">
                                   绑定GitHub第三方账户获取                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/jiuzhibuguniao">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/details/98483020" target="_blank" >
                                        多元线性模型                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/details/97099015" target="_blank" >
                                        C#之事件学习                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/details/89294679" target="_blank" >
                                        使用字典、队列、逻辑规则编写爬虫                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/details/86553977" target="_blank" >
                                        asyncio之于异步IO使用方法                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/details/86548166" target="_blank" >
                                        send函数在yield函数中的作用                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/7039768">
                    <span class="title oneline">c++-primer</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/7674748">
                    <span class="title oneline">Python</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/7680122">
                    <span class="title oneline">Linux</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/7680538">
                    <span class="title oneline">MySQL</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/7692971">
                    <span class="title oneline">Centos</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/7712205">
                    <span class="title oneline">Git</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/8127910">
                    <span class="title oneline">数据结构</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/jiuzhibuguniao/article/category/8436575">
                    <span class="title oneline">基础</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2019/08">
                    2019年8月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2019/07">
                    2019年7月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2019/04">
                    2019年4月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2019/01">
                    2019年1月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2018/12">
                    2018年12月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2018/11">
                    2018年11月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2018/10">
                    2018年10月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2018/06">
                    2018年6月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2018/05">
                    2018年5月                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2018/01">
                    2018年1月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/jiuzhibuguniao/article/month/2017/07">
                    2017年7月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/jiuzhibuguniao/article/details/80726664" >
                                                xshell关闭终端后，程序仍然能够运行                    </a>
					<p class="read">阅读数 <span>2752</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/jiuzhibuguniao/article/details/80464406" >
                                                MySQL连接日志                    </a>
					<p class="read">阅读数 <span>2688</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/jiuzhibuguniao/article/details/80457453" >
                                                MongoClient---Python                    </a>
					<p class="read">阅读数 <span>2675</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/jiuzhibuguniao/article/details/80473656" >
                                                centos7 开启防火墙后，无法远程连接MySQL                    </a>
					<p class="read">阅读数 <span>1103</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/jiuzhibuguniao/article/details/80456675" >
                                                __name__的用法                    </a>
					<p class="read">阅读数 <span>712</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80398008#comments">MySQL在centos7上的安装</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/jiuzhibuguniao" class="user-name" target="_blank">jiuzhibuguniao：</a>[code=sql]
load data local infile &quot;/root/end1.txt&quot; into table operrecord_18061809 fields terminated by ' ';

[/code]                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80398008#comments">MySQL在centos7上的安装</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/jiuzhibuguniao" class="user-name" target="_blank">jiuzhibuguniao：</a>查看MySQL历史命令
[code=sql]
cat /.mysql_history
[/code]                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80398008#comments">MySQL在centos7上的安装</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/jiuzhibuguniao" class="user-name" target="_blank">jiuzhibuguniao：</a>[reply]jiuzhibuguniao[/reply]
加
[code=sql]
fields terminated by ' ';
[/code][code=sql]

[/code]                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80398008#comments">MySQL在centos7上的安装</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/jiuzhibuguniao" class="user-name" target="_blank">jiuzhibuguniao：</a>MySQL下查看表的结构[code=sql]
desc table_name;
[/code]                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80398008#comments">MySQL在centos7上的安装</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/jiuzhibuguniao" class="user-name" target="_blank">jiuzhibuguniao：</a>[code=sql]

update user set user =’sian’ where user =’root’;
[/code][code=sql]
use mysql;
[/code]                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80457613" title="Python追加文件内容">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80465539" title="Centos7配置防火墙">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80457613" title="Python追加文件内容">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/jiuzhibuguniao/article/details/80465539" title="Centos7配置防火墙">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "80464406";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/jiuzhibuguniao/article/details/80464406";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "MySQL连接日志 - jiuzhibuguniao的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u8fde\u63a5","\u65e5\u5fd7"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
